﻿CREATE TABLE [dbo].[Routes] (
    [id]           INT            IDENTITY (1, 1) NOT NULL,
    [number]       NVARCHAR (50)  NOT NULL,
    [name]         NVARCHAR (MAX) NOT NULL,
    [id_routetype] INT            NOT NULL,
	[del]   bit            NULL,
	[price] float			null,
    PRIMARY KEY CLUSTERED ([id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

